﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace Syx.Webapi.AppCode.Entities {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "JK_ZYYZ", DisableSyncStructure = true)]
	public partial class JKZYYZ {

		[JsonProperty, Column(Name = "BDOCTOR_CODE", DbType = "VARCHAR2(100 BYTE)")]
		public string BDOCTORCODE { get; set; }

		[JsonProperty, Column(Name = "BDOCTOR_NAME", DbType = "VARCHAR2(100 BYTE)")]
		public string BDOCTORNAME { get; set; }

		[JsonProperty]
		public int? DAYS { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? DCYL { get; set; }

		[JsonProperty, Column(Name = "DOSAGE_UNITS", DbType = "VARCHAR2(200 BYTE)")]
		public string DOSAGEUNITS { get; set; }

		[JsonProperty, Column(Name = "EDOCTOR_CODE", DbType = "VARCHAR2(100 BYTE)")]
		public string EDOCTORCODE { get; set; }

		[JsonProperty, Column(Name = "EDOCTOR_NAME", DbType = "VARCHAR2(100 BYTE)")]
		public string EDOCTORNAME { get; set; }

		[JsonProperty, Column(Name = "EXECOFFICE_CODE", DbType = "VARCHAR2(200 BYTE)")]
		public string EXECOFFICECODE { get; set; }

		[JsonProperty, Column(Name = "EXECOFFICE_NAME", DbType = "VARCHAR2(200 BYTE)")]
		public string EXECOFFICENAME { get; set; }

		[JsonProperty]
		public int? FLAG { get; set; }

		[JsonProperty, Column(Name = "FLAG_ADD1")]
		public sbyte? FLAGADD1 { get; set; }

		[JsonProperty, Column(Name = "FLAG_ADD2")]
		public sbyte? FLAGADD2 { get; set; }

		[JsonProperty, Column(Name = "FLAG_ADD3")]
		public sbyte? FLAGADD3 { get; set; }

		[JsonProperty, Column(Name = "FLAG_JR")]
		public sbyte? FLAGJR { get; set; }

		[JsonProperty, Column(Name = "FLAG_KJYW")]
		public sbyte? FLAGKJYW { get; set; }

		[JsonProperty, Column(Name = "FLAG_NEW")]
		public sbyte? FLAGNEW { get; set; }

		[JsonProperty, Column(Name = "FLAG_PY")]
		public sbyte? FLAGPY { get; set; }

		[JsonProperty, Column(Name = "FLAG_SS")]
		public sbyte? FLAGSS { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(10 BYTE)")]
		public string JGDW { get; set; }

		[JsonProperty, Column(Name = "JR_CLASS", DbType = "VARCHAR2(50 BYTE)")]
		public string JRCLASS { get; set; }

		[JsonProperty, Column(Name = "KJYW_MD", DbType = "VARCHAR2(100 BYTE)")]
		public string KJYWMD { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? MRCS { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string NAME { get; set; }

		[JsonProperty, Column(Name = "ORDER_CLASS", DbType = "VARCHAR2(50 BYTE)")]
		public string ORDERCLASS { get; set; }

		[JsonProperty, Column(Name = "ORDER_CODE", DbType = "VARCHAR2(100 BYTE)")]
		public string ORDERCODE { get; set; }

		[JsonProperty, Column(Name = "ORDER_DAYS", DbType = "NUMBER(22)")]
		public decimal? ORDERDAYS { get; set; }

		[JsonProperty, Column(Name = "ORDER_MEMO", DbType = "VARCHAR2(50 BYTE)")]
		public string ORDERMEMO { get; set; }

		[JsonProperty, Column(Name = "ORDER_NAME", DbType = "VARCHAR2(1000 BYTE)")]
		public string ORDERNAME { get; set; }

		[JsonProperty, Column(Name = "ORDER_SPECI", DbType = "VARCHAR2(200 BYTE)")]
		public string ORDERSPECI { get; set; }

		[JsonProperty, Column(Name = "PATIENT_ID", DbType = "VARCHAR2(50 BYTE)")]
		public string PATIENTID { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? PLCS { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? PLJG { get; set; }

		[JsonProperty, Column(Name = "QTY_DAY", DbType = "NUMBER(22)")]
		public decimal? QTYDAY { get; set; }

		[JsonProperty, Column(Name = "QTY_SUM", DbType = "NUMBER(22)")]
		public decimal? QTYSUM { get; set; }

		[JsonProperty, Column(Name = "START_DATE", DbType = "DATE(7)")]
		public DateTime? STARTDATE { get; set; }

		[JsonProperty, Column(Name = "STOP_DATE", DbType = "DATE(7)")]
		public DateTime? STOPDATE { get; set; }

		[JsonProperty, Column(Name = "TAB_ID")]
		public int TABID { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string USEMEDIWAY { get; set; }

		[JsonProperty, Column(Name = "VISIT_ID", DbType = "VARCHAR2(10 BYTE)")]
		public string VISITID { get; set; }

		[JsonProperty]
		public int? XH { get; set; }

		[JsonProperty, Column(DbType = "NUMBER(22)")]
		public decimal? YPDJ { get; set; }

		[JsonProperty]
		public int? ZBXH { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(30 BYTE)")]
		public string ZXPC { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(50 BYTE)")]
		public string ZYID { get; set; }

	}

}
